package com.fengxing.ams.web.facade.mouble.batchline;

import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;
import org.springframework.data.repository.query.Param;

public interface IBatchLineDAO extends PagingAndSortingRepository<BatchLineVO, String>, JpaSpecificationExecutor<BatchLineVO>  {

	@Query("select t from BatchLineVO t where t.year = :year and t.clazz= :clazz order by t.score")
	List<BatchLineVO> getBatchLine(@Param("year")Integer year, @Param("clazz")String type);
	@Query("select t from BatchLineVO t where t.year = :year order by t.clazz,t.score desc")
	List<BatchLineVO> getBatchLine(@Param("year") Integer year);

}
